You can specify advanced options on the index as well as define multiple columns in the same index with ascending or descending order clause Ddl 。您可以在索引上指定高级选项,以及用ascending或descending order子句在同一索引中定义多个列。
If the data file is sorted in a different order , that is other than the order of a clustered index key , or if there is no clustered index on the table , the order clause is ignored 如果根据表中的聚集索引对要加载的数据排序,则可提高大容量复制的性能。如果数据文件按不同次序排序,或者该表没有聚集索引,则将忽略order提示。